/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1010

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 20 2d 2d 20 45 52 77 |TRICT.  |  -- ERw|
|00000020| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000030| 74 69 6d 65 0d 0a 20 20 | 20 20 2d 2d 20 25 50 61 |time..  |  -- %Pa|
|00000040| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00000050| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00000060| 20 55 50 44 41 54 45 20 | 52 45 53 54 52 49 43 54 | UPDATE |RESTRICT|
|00000070| 20 0d 0a 20 20 20 20 77 | 68 65 6e 20 28 0d 0a 20 | ..    w|hen (.. |
|00000080| 20 20 20 20 20 2d 2d 20 | 25 25 4e 6f 74 6e 75 6c |     -- |%%Notnul|
|00000090| 6c 46 4b 28 69 6e 73 65 | 72 74 65 64 2c 22 20 69 |lFK(inse|rted," i|
|000000a0| 73 20 6e 6f 74 20 6e 75 | 6c 6c 20 61 6e 64 22 29 |s not nu|ll and")|
|000000b0| 20 0d 0a 20 20 20 20 20 | 20 25 4e 6f 74 6e 75 6c | ..     | %Notnul|
|000000c0| 6c 46 4b 28 69 6e 73 65 | 72 74 65 64 2c 22 20 69 |lFK(inse|rted," i|
|000000d0| 73 20 6e 6f 74 20 6e 75 | 6c 6c 20 61 6e 64 22 29 |s not nu|ll and")|
|000000e0| 0d 0a 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |..      |not exis|
|000000f0| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 73 65 |ts (..  |      se|
|00000100| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 25 50 61 72 |lect * f|rom %Par|
|00000110| 65 6e 74 0d 0a 20 20 20 | 20 20 20 20 20 77 68 65 |ent..   |     whe|
|00000120| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 20 20 2d 2d |re..    |      --|
|00000130| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 | %%JoinF|KPK(inse|
|00000140| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00000150| 20 22 2c 22 20 61 6e 64 | 22 29 20 0d 0a 20 20 20 | "," and|") ..   |
|00000160| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00000170| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00000180| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|00000190| 0a 20 20 20 20 20 20 29 | 0d 0a 20 20 20 20 29 0d |.      )|..    ).|
|000001a0| 0a 20 20 20 20 20 20 28 | 65 78 65 63 75 74 65 20 |.      (|execute |
|000001b0| 70 72 6f 63 65 64 75 72 | 65 20 65 72 77 69 6e 5f |procedur|e erwin_|
|000001c0| 72 61 69 73 65 5f 65 78 | 63 65 70 74 28 0d 0a 20 |raise_ex|cept(.. |
|000001d0| 20 20 20 20 20 20 20 2d | 37 34 36 2c 0d 0a 20 20 |       -|746,..  |
|000001e0| 20 20 20 20 20 20 27 43 | 61 6e 6e 6f 74 20 55 50 |      'C|annot UP|
|000001f0| 44 41 54 45 20 22 25 43 | 68 69 6c 64 22 20 62 65 |DATE "%C|hild" be|
|00000200| 63 61 75 73 65 20 22 25 | 50 61 72 65 6e 74 22 20 |cause "%|Parent" |
|00000210| 64 6f 65 73 20 6e 6f 74 | 20 65 78 69 73 74 2e 27 |does not| exist.'|
|00000220| 0d 0a 20 20 20 20 20 20 | 29 29 2c 0d 0a 00 1c 27 |..      |)),....'|
+--------+-------------------------+-------------------------+--------+--------+